Problem Note 48631: Erroneous messages appear in the SAS® Anti-Money Laundering Related Entities window when the FSC_PARTY_DIM table has missing address information
 |  |  |  |  |
Missing or blank values in the address columns of the FSC_PARTY_DIM table might cause erroneous messages, such as the following, in the Related Entities window:
"0 of 454 total rows displayed"
"No matchs for this value"
You might also see partial or missing address information under the Mailing Address and Street Address sections.
This problem has been linked to the SQL queries that perform the matching of the address match codes. The queries do not ignore blank address match codes.
The queries have been rewritten to address this problem.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Anti-Money Laundering | Microsoft® Windows® for x64 | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 for x64 | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2008 | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2008 for x64 | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows XP Professional | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Enterprise 32 bit | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Enterprise x64 | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Home Premium 32 bit | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Home Premium x64 | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Professional 32 bit | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Professional x64 | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Ultimate 32 bit | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Ultimate x64 | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows Vista | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows Vista for x64 | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| 64-bit Enabled AIX | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| 64-bit Enabled HP-UX | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| 64-bit Enabled Solaris | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| HP-UX IPF | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Linux | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Linux for x64 | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Solaris for x64 | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
A fix for this issue for SAS Anti-Money Laundering 4.2 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/D05.html#48631
The UI queries do not ignore blank value match codes. This results in all other entities in the database to be taken into account.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2013-01-08 14:28:46 |
| Date Created: | 2012-12-07 16:15:55 |